﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using Runda.CMS.Common.Utility;
using System.Data;
using System.Data.Common;

namespace Runda.CMS.Dal
{
    public partial class CtrtInstrumentCategoryDal : DalBase
    {
        public DataTable GetInstrumentCategory(string WhereClause)
        {
            StringBuilder sbSql = new StringBuilder("select * from Cms_Ctrt_InstrumentCategory where 1=1 ");

            sbSql.Append(WhereClause).Append(" order by categoryCode");

            DbCommand dbcommand = CurrentDatabase.GetSqlStringCommand(sbSql.ToString());

            return CurrentDatabase.ExecuteDataSet(dbcommand).Tables[0];
        }
    }
}
